package com.portal.cwegportal.mapper;

import com.portal.cwegportal.model.File;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

@org.apache.ibatis.annotations.Mapper
@Repository
public interface FileMapper  extends Mapper<File> {
    @Select("update file set is_deleted=1 where business_type=#{business_type} and business_id=#{business_id} and file_class=#{file_class} and is_deleted=0")
    List<File> deleteFile(String  business_type,String business_id,String file_class);
}
